The Replenishment Item Quantity table contains data used by the Replenishment module. The table displays the inventory for each item and variant at each location, in addition to what is expected to be received at the location (Quantity on Purchase Order and Quantity in Transfer In) and what is to be shipped out from the location (Quantity on Sales Order and Quantity in Transfer Out). It also contains information about Average Daily Sales and the No. of days Out of Stock if the Stock Out functionality is in use.
The Replenishment Item Quantity table provides the input to the function Add Items to the Purchase and Transfer Replenishment Journals. The Replenishment Item Quantity records can be calculated as a pre-process to adding lines to the journals, but would most likely be calculated in an automatic Scheduler Job during overnight processing.
The Replenishment Item Quantity calculation process only creates records for valid items and valid locations for the replenishment process.
Fields
| Field Name | Description |
|---|---|
| Item No. | The Item Number. |
| Variant Code | The Variant Code. |
| Location Code | The Location Code of a Store that is valid for replenishment and the location code of a warehouse that is the default warehouse as defined in the Replenishment From Warehouse table. |
| Inventory | The Inventory Status of records Location Code. If the field Calc. Qty. Sold not Posted in the Replenishment Setup record is set, the value of the field Qty. Sold not Posted has been subtracted from the Inventory status. |
| Quantity on Purchase Order | The sum of the field Outstanding Qty. (Base) in all Purchase Order Lines. |
| Quantity on Sales Order | The sum of the field Outstanding Qty. (Base) in all Sales Order Lines. |
| Quantity in Transfer In | The sum Outstanding Qty. (Base) and Qty. in Transit (Base) of all Transfer Order Lines where the Location Code is filtered to the field Transfer-to Code. |
| Quantity in Transfer Out | The sum Outstanding Qty. (Base) of all Transfer Order Lines where the Location Code is filtered to the field Transfer-from Code. |
| Date Modified | The date when the record was last modified. |
| Time Modified | The time when the record was last modified. |
| Daily Sales | Calculated average daily sales. |
| Sales Date From | The From Date used in the average daily sales calculation. This is influenced by the used Sales Profile and first date of sale. |
| Sales Date To | The To Date used in the average daily sales calculation. This is influenced by the used Sales Profile. |
| No. of Sales Dates | The number of days in the calculation of the Daily Sale. |
| No. of Days Out of Stock | The number of days of zero stock days. |
| Date of First Sale | The date when the item was sold for the first time. |
| Adjusted Sales | The quantity the sales quantity was adjusted by, according to entries in the Replenishment Sales History Adjustments. |
| Qty. Sold not Posted | The quantity of Transaction records that have not been posted in a Statement. This field is only calculated if the field Calc. Qty. Sold not Posted is set in the Replenishment Setup record. |
| Replenish From Warehouse | The Location Code of the warehouse the record will be replenished from. |
| Item Division Code | The Division Code of the Item No. It is used for filtering when adding items to journals. |
| Item Category Code | The Item Category Code of the Item No. Used for filtering when adding items to journals. |
| Item Product Group Code | The Product Group Code of the Item No. Used for filtering when adding items to journals. |
| Vendor No. | The Vendor No. that is going to be used when creating a Purchase Order. |
| Replenishment Calculation Type | The Replenishment Calculation Type to be used in the replenishment process |
| Replenish as Location Code | Filled in if the sales history is to be used from another Location Code. |
| Season Code | The Season Code of the Item No. |
| Replenish as Item No. | Filled in if the sales history is to be used from another Item No. |
| Planned Sales Demand | The quantity from the Replenishment Planned Sales Demand records to overwrite the calculated daily sales amount from sales history. |
| PO Blocked | Set if the Item No. is blocked for Purchase Orders from the Item Status table. |
| TO Blocked | Set if the Item No. is blocked for Transfer Orders from the Item Status table. |
| Is a Whse | The Location Code of the record is a warehouse. |
| Replen. Whse Data Exists | An Item Store record exists for the warehouse. |
| Replen. Source | Specifies if the Replenishment Data is from the Item, Item Store or Data Profile record. |
| Replen. Code | Contains the Item No. or the Data Profile Code. |
| Replen. Variant | The Variant Code. |
| Replen. Location | The Location Code of the Item Store record. |
| Replen. Valid | Contains the Valid from date for the Item Store or the Data Profile record. |
| In Distribution | Set if the Item No is in distribution for the Location. |
| Data Source | Specifies if the location belongs to the local company or another company, and if the location consists of child locations. |
| Data Source Company | The name of the company to which the location belongs. |
| Is Child Location | Specifies if the location is a child of another location. |
Calculation of Replenishment Quantity
The calculation of the Replenishment Item Quantity table can be run overnight by the Scheduler:
See Also
Calculation of the Replenishment Item Quantities table